1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| CREATE TABLE /*!32312 IF NOT EXISTS*/ "table_billing" (
"client" int(11) DEFAULT NULL,
"billing_date" datetime DEFAULT NULL,
"price" int(11) DEFAULT NULL
);
#
# Dumping data for table 'table_billing'
#
LOCK TABLES "table_billing" WRITE;
/*!40000 ALTER TABLE "table_billing" DISABLE KEYS;*/
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(1456,'2009-01-01 01:10:00',0);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(4542,'2009-01-01 02:00:00',30);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(1456,'2009-01-01 03:00:00',10);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(7894,'2009-01-01 04:00:00',44);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(4585,'2009-01-01 05:00:00',55);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(1456,'2009-01-01 01:10:00',0);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(6527,'2009-01-02 01:00:00',0);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(3658,'2009-01-02 02:00:00',91);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(7459,'2009-01-02 03:00:00',1);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(6310,'2009-01-02 04:00:00',0);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(7459,'2009-01-02 00:00:00',100);
REPLACE INTO "table_billing" ("client", "billing_date", "price") VALUES
(6310,'2009-01-02 04:00:00',0);
/*!40000 ALTER TABLE "table_billing" ENABLE KEYS;*/
UNLOCK TABLES; |
Partager